-- UAP报表脚本(数量: 1张 生成时间:2019年8月21日 19:42)
-- 1.错误日志查询( 1个视图,项目号U8CUSTDEF)
-- "错误日志查询"
-- 添加新的UAP报表
-- 插入项目信息
DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF'
INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/8/21 18:57:15',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
GO
-- UAP报表数据报表级基础信息
DELETE FROM UAP_Report WHERE ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a'
INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'7EE838E9-F251-46A4-8853-072868EC69E5',N'c643043a-03e0-48b9-9320-61501317cef7',N'Function1',N'',N'U8CUSTDEF',N'SA',N'Report.ErrorReport,Report',N'',N'0',N'0',N'demo',N'2019/8/21 17:25:56',N'0',N'',N'',N'',N'1',N'SARPT213639',NULL,N'1',NULL,N'1',NULL)
GO
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'en-US'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'en-US',N'错误日志查询',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'zh-CN'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'zh-CN',N'错误日志查询',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'zh-TW'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'zh-TW',N'错误日志查询',NULL,N'0')
GO
DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a'
INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'fcb05799-1092-4653-b7e5-271e59d452a2')
GO
-- UAP报表数据源:可能包含进行扩展后的BO对象
DELETE FROM BD_BusinessObjects WHERE MetaID=N'c643043a-03e0-48b9-9320-61501317cef7'
INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'c643043a-03e0-48b9-9320-61501317cef7',N'错误日志查询(2019-08-21 下午 19:43:01)',N'U8CUSTDEF',N'SA',N'
',N'错误日志查询',N'ReportBO',N'',N'0')
GO
-- UAP报表过滤条件
DELETE FROM flt_DefineMeta_Cust WHERE FilterId=N'7EE838E9-F251-46A4-8853-072868EC69E5'
DELETE FROM flt_DefineMeta_Cache WHERE FilterId=N'7EE838E9-F251-46A4-8853-072868EC69E5'
DELETE FROM flt_DefineMeta_Base WHERE FilterID=N'7EE838E9-F251-46A4-8853-072868EC69E5'
INSERT INTO flt_DefineMeta_Base(FilterID,ProjectNO,XMLExpression,SubNO,FilterName,FilterDesc,IsUpgrade,bLocked,cLockedBy,PersonItems)VALUES(N'7EE838E9-F251-46A4-8853-072868EC69E5',N'U8CUSTDEF',N'